Bookmark Property (Remote Data)

       

Returns or sets a bookmark that uniquely identifies the current row in an rdoResultset object. If you have a valid bookmark, you can use it to reposition the current row in an rdoResultset.

Syntax

object.Bookmark [= value]

The Bookmark property syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
value A Variant(string) expression that evaluates to a valid bookmark.

Remarks

When a non-forward-only-type rdoResultset object is created or opened, each of its rows already has a unique bookmark. You can save the bookmark for the current row by assigning the value of the Bookmark property to a variable declared as Variant. To quickly return to that row at any time after moving to a different row, set the rdoResultset object's Bookmark property to the value of that variable.

There is no limit to the number of bookmarks you can establish. To create a bookmark for a row other than the current row, move to the desired row and assign the value of the Bookmark property to a Variant variable that identifies the row.

To make sure the rdoResultset supports bookmarks, inspect the value of its Bookmarkable property before you use the Bookmark property. If Bookmarkable is False, the rdoResultset doesn't support bookmarks, and using the Bookmark property results in a trappable error. While a bookmark value might be returned when using a dynamic cursor, this value cannot always be trusted.

The value of the Bookmark property isn't guaranteed to be the same as a row number.

Note   The Bookmark property doesn't apply to forward-only type rdoResultset objects.